/*
 Navicat MySQL Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : bill-manager

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 13/11/2020 10:10:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bill_
-- ----------------------------
DROP TABLE IF EXISTS `bill_`;
CREATE TABLE `bill_` (
  `id_` bigint(20) NOT NULL AUTO_INCREMENT,
  `title_` varchar(100) DEFAULT NULL,
  `bill_time_` date DEFAULT NULL,
  `type_id_` bigint(20) DEFAULT NULL,
  `price_` double(10,2) DEFAULT NULL,
  `explain_` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id_`),
  KEY `fk_type_bill` (`type_id_`),
  CONSTRAINT `fk_type_bill` FOREIGN KEY (`type_id_`) REFERENCES `bill_type_` (`id_`)
) ENGINE=InnoDB AUTO_INCREMENT=458 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bill_
-- ----------------------------
BEGIN;
INSERT INTO `bill_` VALUES (21, '采购办公用品2222', '2019-05-29', 3, 666.00, 'ddddd');
INSERT INTO `bill_` VALUES (23, 'as', '2020-11-22', 2, 22.30, '买给熊大22');
INSERT INTO `bill_` VALUES (29, 'as', '2020-11-22', 3, 22.30, '');
INSERT INTO `bill_` VALUES (35, 'df', '2020-11-06', 3, 22.30, '买给熊大');
INSERT INTO `bill_` VALUES (92, 'abcdefg', '2019-05-22', 3, 666.00, '1234');
INSERT INTO `bill_` VALUES (93, '采购办公用品', '2019-05-22', 4, 666.00, '采购办公用品');
INSERT INTO `bill_` VALUES (94, '采购办公用品', '2019-05-22', 4, 666.00, '采购办公用品');
INSERT INTO `bill_` VALUES (103, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (104, '帮别人改bug', '2020-11-22', 3, 22.30, '给学生');
INSERT INTO `bill_` VALUES (105, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (106, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (107, 'aw', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (108, 'r', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (109, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (110, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (111, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (112, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (113, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (114, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (115, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (116, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (117, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (118, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (119, 'wsd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (120, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (121, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (122, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (123, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (124, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (125, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (126, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (127, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (128, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (129, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (130, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (131, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (133, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (134, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (135, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (136, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (137, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (138, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (139, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (140, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (141, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (142, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (143, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (144, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (145, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (146, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (147, 'awer', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (148, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (149, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (150, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (151, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (152, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (153, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (154, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (155, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (156, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (157, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (158, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (159, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (160, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (161, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (162, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (163, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (164, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (165, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (166, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (167, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (168, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (169, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (170, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (171, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (172, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (173, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (174, 'wsdr', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (175, 'wae', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (176, 's', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (177, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (178, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (179, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (180, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (181, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (182, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (183, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (184, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (185, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (186, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (187, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (188, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (189, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (190, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (191, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (192, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (193, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (194, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (195, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (196, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (197, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (198, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (199, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (200, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (201, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (202, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (203, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (204, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (205, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (206, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (207, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (208, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (209, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (210, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (211, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (212, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (213, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (214, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (215, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (216, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (217, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (218, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (219, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (220, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (221, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (222, 'fd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (223, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (224, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (225, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (226, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (227, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (228, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (229, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (230, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (231, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (232, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (233, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (234, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (235, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (236, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (237, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (238, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (239, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (240, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (241, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (242, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (243, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (244, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (245, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (246, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (247, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (248, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (249, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (250, 'asfd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (251, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (252, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (253, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (254, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (255, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (256, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (257, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (258, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (259, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (260, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (261, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (262, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (263, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (264, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (265, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (266, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (267, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (268, 'fas', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (269, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (270, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (271, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (272, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (273, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (274, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (275, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (276, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (277, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (278, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (279, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (280, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (281, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (282, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (283, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (284, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (285, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (286, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (287, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (288, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (289, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (290, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (291, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (292, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (293, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (294, 'awe', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (295, 'r', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (296, 'sd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (297, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (298, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (299, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (300, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (301, 'sd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (302, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (303, 'sd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (304, 'r', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (305, 'qwae', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (306, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (307, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (308, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (309, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (310, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (311, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (312, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (313, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (314, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (315, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (316, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (317, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (318, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (319, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (320, 'fas', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (321, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (322, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (323, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (324, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (325, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (326, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (327, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (328, 'asf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (329, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (330, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (331, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (332, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (333, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (334, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (335, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (336, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (337, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (338, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (339, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (340, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (341, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (342, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (343, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (344, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (345, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (346, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (347, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (348, 'fd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (349, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (350, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (351, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (352, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (353, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (354, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (355, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (356, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (357, 'sd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (358, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (359, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (360, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (361, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (362, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (363, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (364, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (365, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (366, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (367, 'sa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (368, 'fdasfd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (369, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (370, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (371, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (372, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (373, 'd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (374, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (375, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (376, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (377, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (378, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (379, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (380, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (381, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (382, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (383, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (384, 'a', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (385, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (386, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (387, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (388, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (389, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (390, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (391, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (392, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (393, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (394, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (395, 'sadf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (396, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (397, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (398, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (399, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (400, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (401, 'fd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (402, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (403, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (404, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (405, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (406, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (407, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (408, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (409, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (410, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (411, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (412, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (413, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (414, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (415, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (416, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (417, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (418, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (419, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (420, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (421, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (422, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (423, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (424, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (425, 'asfd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (426, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (427, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (428, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (429, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (430, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (431, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (432, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (433, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (434, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (435, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (436, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (437, 'sdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (438, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (439, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (440, 'f', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (441, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (442, 'sad', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (443, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (444, 'as', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (445, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (446, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (447, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (448, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (449, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (450, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (451, 'sadf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (452, 'asd', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (453, 'fa', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (454, 'df', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (455, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (456, 'asdf', NULL, NULL, NULL, NULL);
INSERT INTO `bill_` VALUES (457, 'asdf', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for bill_type_
-- ----------------------------
DROP TABLE IF EXISTS `bill_type_`;
CREATE TABLE `bill_type_` (
  `id_` bigint(20) NOT NULL AUTO_INCREMENT,
  `name_` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id_`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bill_type_
-- ----------------------------
BEGIN;
INSERT INTO `bill_type_` VALUES (1, '收入');
INSERT INTO `bill_type_` VALUES (2, '支出');
INSERT INTO `bill_type_` VALUES (3, '借入');
INSERT INTO `bill_type_` VALUES (4, '借出');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
